>>> df.groupby('id').first() value id 1 first 2 first 3 first 4 second 5 first 6 first 7 fourth